<div class="Content">
   <div>
       <img src="<?=$theme_path?>images/layout/inbox_temp1.png" alt="">
   </div>
</div>

-- phpMyAdmin SQL Dump
-- version 3.4.10.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Sep 17, 2012 at 03:03 PM
-- Server version: 5.0.95
-- PHP Version: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `nguyenh1_livingnext`
--

-- --------------------------------------------------------

--
-- Table structure for table `billing_detail`
--

CREATE TABLE IF NOT EXISTS `billing_detail` (
`id` int(11) NOT NULL auto_increment,
`profile_id` int(11) default NULL,
`date` int(11) default NULL,
`billing_name_id` int(11) default NULL,
`amount` double default NULL,
PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=6 ;

--
-- Dumping data for table `billing_detail`
--

INSERT INTO `billing_detail` (`id`, `profile_id`, `date`, `billing_name_id`, `amount`) VALUES
(1, 6, 1347604597, 1, 0),
(2, 6, 1347604597, 2, 0),
(3, 6, 1347604597, 1, 0),
(4, 6, 1347604597, 1, 0),
(5, 6, 1347604597, 1, 0);

-- --------------------------------------------------------

--
-- Table structure for table `billing_name`
--

CREATE TABLE IF NOT EXISTS `billing_name` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) collate utf8_unicode_ci default NULL,
`modified_date` int(11) default NULL,
PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

--
-- Dumping data for table `billing_name`
--

INSERT INTO `billing_name` (`id`, `name`, `modified_date`) VALUES
(1, 'Electricity Bill', NULL),
(2, 'Water Bill', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `book`
--

CREATE TABLE IF NOT EXISTS `book` (
`id` int(11) NOT NULL auto_increment,
`category_id` int(11) default NULL,
`title` varchar(255) character set utf8 default NULL,
`date_issue` int(11) default NULL,
`description` text character set utf8,
`author` varchar(255) character set utf8 default NULL,
`thumbnail_path` varchar(255) default NULL,
`file_path` varchar(255) character set utf8 default NULL,
PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `book`
--

INSERT INTO `book` (`id`, `category_id`, `title`, `date_issue`, `description`, `author`, `thumbnail_path`, `file_path`) VALUES
(2, 1, 'ds,f', 1345018360, '<p>ngklfnglk</p>', 'flknglkfdn', 'uploads/1345000392.jpg', 'uploads/books/1345001078.docx'),
(3, 6, 'kjdfghkjdfhg', 1345018352, '<p>jdfgdfnl</p>', 'ldflgkdfjlk', '', ''),
(4, 1, 'm,gfkldfjglk', 1345018356, '<p>lkdfnmgkldnl</p>', 'lkdfnglkdfn', '', ''),
(5, 1, 'fdglkfdglk', 1345018384, '', '', '', ''),
(6, 1, '22222222222', 1345018389, '', '', '', ''),
(7, 1, 'Cuốn theo chiều gió', 1345018395, 'nội dung mang tính minh hoạ', 'Victor Hugo', '', ''),
(8, 4, 'TTTTTTTTTTTTTTTTTTTTTTTT', 1345025025, '', '', '', '');

-- --------------------------------------------------------

--
-- Table structure for table `category`
--

CREATE TABLE IF NOT EXISTS `category` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(255) character set utf8 default NULL,
`description` text character set utf8,
PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `category`
--

INSERT INTO `category` (`id`, `title`, `description`) VALUES
(1, 'Tiểu thuyết trữ tình lãng mạn', '<p>dkfngfjls</p>'),
(3, 'aaaaaaaa', ''),
(4, 'bbbbbb', ''),
(5, 'ksjoiwejrtoiejtrlkerew', ''),
(6, '.f,gkf', '');

-- --------------------------------------------------------

--
-- Table structure for table `comment_profile`
--

CREATE TABLE IF NOT EXISTS `comment_profile` (
`id` int(11) NOT NULL auto_increment,
`profile_id` int(11) default NULL,
`friend_id` int(11) default NULL,
`event_id` int(11) default NULL,
`content` text,
`comment_date` int(11) default NULL,
PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ;

--
-- Dumping data for table `comment_profile`
--

INSERT INTO `comment_profile` (`id`, `profile_id`, `friend_id`, `event_id`, `content`, `comment_date`) VALUES
(1, 2, 3, NULL, 'ABC1', NULL),
(2, 2, 4, NULL, 'ABC 2', NULL),
(3, 2, 5, NULL, 'abc 3\r\n', NULL),
(4, 3, 2, NULL, 'wtf 1', NULL),
(5, 3, 2, NULL, 'wtf 3', NULL),
(6, 3, 4, NULL, 'test 1', NULL),
(7, 2, 5, NULL, 'sddssdsd', NULL),
(8, 2, 5, NULL, 'dssddssdsd', NULL),
(9, 5, 2, NULL, 'dddssd', NULL),
(10, 5, 2, NULL, 'con ket', NULL),
(11, 3, 2, NULL, 'shit nam', NULL),
(12, 5, 2, NULL, 'con ket', NULL),
(13, 2, 4, NULL, 'Test 1', NULL),
(14, 4, 2, NULL, 'WTH', NULL),
(15, 2, 2, NULL, 'abc', NULL),
(16, 2, 2, NULL, '0', NULL),
(17, 2, 2, NULL, 'def', NULL),
(18, 2, 2, NULL, '0', NULL),
(19, 2, 2, NULL, '0', NULL),
(20, 2, 2, NULL, '0', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `connection`
--

CREATE TABLE IF NOT EXISTS `connection` (
`id` int(11) NOT NULL auto_increment,
`profile_id` int(11) default NULL,
`friend_id` int(11) default NULL COMMENT 'reference to id profile',
`date_added` int(11) default NULL,
`access_scope` int(11) default NULL,
PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `connection`
--

INSERT INTO `connection` (`id`, `profile_id`, `friend_id`, `date_added`, `access_scope`) VALUES
(1, 2, 3, NULL, NULL),
(2, 2, 4, NULL, NULL),
(3, 2, 5, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `event`
--

CREATE TABLE IF NOT EXISTS `event` (
`id` int(11) NOT NULL auto_increment,
`profile_id` int(11) default NULL,
`event_name` text,
`event_placed` text,
`event_started` int(11) default NULL,
`event_ended` int(11) default NULL,
`details` text,
PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `event`
--

INSERT INTO `event` (`id`, `profile_id`, `event_name`, `event_placed`, `event_started`, `event_ended`, `details`) VALUES
(1, 3, 'Hello Living Next', '123A Phuong ABC, Quan DEF, Ho Chi Minh', 12345671, 12345671, 'no name');

-- --------------------------------------------------------

--
-- Table structure for table `event_comment`
--

CREATE TABLE IF NOT EXISTS `event_comment` (
`id` int(11) NOT NULL auto_increment,
`event_id` int(11) default NULL,
`profile_id` int(11) default NULL,
`content` varchar(1000) collate utf8_unicode_ci default NULL,
`created_date` int(11) default NULL,
PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `event_member`
--

CREATE TABLE IF NOT EXISTS `event_member` (
`id` int(11) NOT NULL auto_increment,
`event_id` int(11) default NULL,
`profile_id` int(11) default NULL,
`status_code` int(11) default NULL,
`date_join` int(11) default NULL,
KEY `id` (`id`),
KEY `id_2` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `event_member`
--

INSERT INTO `event_member` (`id`, `event_id`, `profile_id`, `status_code`, `date_join`) VALUES
(1, 1, 2, 1, NULL),
(2, 1, 3, 4, NULL),
(3, 1, 4, 2, NULL),
(4, 1, 5, 5, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `event_status`
--

CREATE TABLE IF NOT EXISTS `event_status` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(50) default NULL,
`code` varchar(10) default NULL,
PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `event_status`
--

INSERT INTO `event_status` (`id`, `name`, `code`) VALUES
(1, 'Going', 'G'),
(2, 'Join', 'J'),
(3, 'May be', 'MB'),
(4, 'Decline', 'D'),
(5, 'Not Going', 'NG');

-- --------------------------------------------------------

--
-- Table structure for table `life_dimension`
--

CREATE TABLE IF NOT EXISTS `life_dimension` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(255) collate utf8_unicode_ci default NULL,
`content_vi` text collate utf8_unicode_ci,
`content_en` int(11) default NULL,
`image` varchar(255) collate utf8_unicode_ci default NULL,
`created_date` int(11) default NULL,
`modified_date` int(11) default NULL,
PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `life_dimension_category`
--

CREATE TABLE IF NOT EXISTS `life_dimension_category` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) collate utf8_unicode_ci default NULL,
`modified_date` int(11) default NULL,
PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `life_dimension_review`
--

CREATE TABLE IF NOT EXISTS `life_dimension_review` (
`id` int(11) NOT NULL auto_increment,
`life_dimension_id` int(11) default NULL,
`profile_id` int(11) default NULL,
`title` varchar(255) collate utf8_unicode_ci default NULL,
`review` varchar(1000) collate utf8_unicode_ci default NULL,
`rating` int(11) default NULL,
`status` varchar(255) collate utf8_unicode_ci default NULL COMMENT 'ACTIVE, INACTIVE',
`modified_date` int(11) default NULL,
PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `measurement_unit`
--

CREATE TABLE IF NOT EXISTS `measurement_unit` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) collate utf8_unicode_ci default NULL,
`modified_date` int(11) default NULL,
PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

--
-- Dumping data for table `measurement_unit`
--

INSERT INTO `measurement_unit` (`id`, `name`, `modified_date`) VALUES
(1, 'Cuốn', 0),
(2, 'Page', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `profile`
--

CREATE TABLE IF NOT EXISTS `profile` (
`id` int(11) NOT NULL auto_increment,
`full_name` varchar(50) default NULL,
`position` varchar(50) default NULL,
`skills` text,
`interested` text,
`company` varchar(50) default NULL,
`created_date` int(11) default NULL,
`image_profile` varchar(50) default NULL,
`phone_number` int(11) default NULL,
`email` text,
`password` varchar(50) default NULL,
`location` varchar(50) default NULL,
`birthday` int(11) default NULL,
`logged` bit(1) default b'0' COMMENT 'Nhan biet tinh trang dang nhap hay chua',
PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

-- --------------------------------------------------------

--
-- Table structure for table `review`
--

CREATE TABLE IF NOT EXISTS `review` (
`id` int(11) NOT NULL auto_increment,
`book_id` int(11) default NULL,
`profile_id` int(11) default NULL,
`title` varchar(255) collate utf8_unicode_ci default NULL,
`review` text collate utf8_unicode_ci,
`rating` int(11) default NULL,
`status` varchar(255) collate utf8_unicode_ci default NULL,
`created_date` int(11) default NULL,
PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=52 ;

--
-- Dumping data for table `review`
--

INSERT INTO `review` (`id`, `book_id`, `profile_id`, `title`, `review`, `rating`, `status`, `created_date`) VALUES
(51, 13, 6, 'tiêu đề 3', 'nội dugn khá tốt', 12, 'active', NULL),
(50, 13, 6, 'binh thuong', 'binh thuong', 12, 'active', NULL),
(49, 13, 6, 'win tieu de', 'toi rat thik cuon sach nay', 16, 'active', NULL),
(48, 13, 6, 'tiêu đề 2', 'nội dung bình thường', 16, 'active', NULL),
(47, 13, 6, 'tiêu đề', 'nội dung hấp dẫn', 8, 'active', NULL);

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
